Cluster Based Approach for Selection of Materialized Views
نویسندگان
چکیده
A data warehouse (DW) is a database used for reporting and decision support services of an organization. A thousand of queries are fired in every second to actual database or data warehouse and replying each query in quick time with accuracy is a great concern. Queries to DW are critical regarding to their complexity and length. They often access millions of tuples, and involve joins between relations and aggregations. Materialized views are able to provide the better performance for DW queries. A novel algorithm is proposed for selection of materialized view using query clustering strategy that reduces the execution time as compared to response time for actual database.
منابع مشابه
Markov Chain for the Recommendation of Materialized Views in Real-time Data Warehouse
In this paper we propose an approach, which is based on Markov Chain, to cluster and recommend candidate views for the selection algorithm of materialized views. Our idea is to intervene at regular period of time in order to filter the candidate views which will be used by an algorithm for the selection of materialized views in real-time data warehouse. The aim is to reduce the complexity and t...
متن کاملSelecting Materialized Views based on Genetic Algorithm
As the data sets increase in data warehouse day by day, the cost used for OLAP operations becomes extremely high. One of the most effective ways to solve this problem is to build appropriate materialized views in the data warehouse. In order to select the appropriate views to be materialized with the possible minimized cost, we propose a novel approach to the materialized view selection problem...
متن کاملAn Approach for Selection and Maintenance of Materialized View in Data Warehousing
Quick response time and accuracy are important factors in the success of any database. In large databases particularly in distributed database, query response time plays an important role as timely access to information and it is the basic requirement of successful business application. A data warehouse uses multiple materialized views to efficiently process a given set of queries. The material...
متن کاملA Solution to View Management to Build a Data Warehouse
Several techniques exist to select and materialize a proper set of data in a suitable structure that manage the queries submitted to the online analytical processing systems. These techniques are called view management techniques, which consist of three research areas: 1) view selection to materialize, 2) query processing and rewriting using the materialized views, and 3) maintaining materializ...
متن کاملAn Efficient Materialized View Selection Approach for Query Processing in Database Management
Quick response time and accuracy are important factors in the success of any database. In large databases particularly in distributed database, query response time plays an important role as timely access to information and it is the basic requirement of successful business application. A data warehouse uses multiple materialized views to efficiently process a given set of queries. The material...
متن کامل